<?php
	define('CONFIG_FILE',true);
	include './config.php';

	define('DB_FILE',true);
	require_once '../Tool/DB/SqlDBManager.class.php';

	$sqlDBManager = new SqlDBManager();

	$page = isset($_POST['page']) ? intval($_POST['page']) : 1;
	$rows = isset($_POST['rows']) ? intval($_POST['rows']) : 10;
	$offset = ($page-1)*$rows;
	$result = array();

	$sql = "select count(*) from attendancerecord";
	$res=$sqlDBManager->queryRows($sql);
	if(!empty($res)){
		$result["total"] = $res[0];
	}
	else{
		$result["total"] = 0;
	}

	$sql = "select * from attendancerecord limit $offset,$rows";
	$res=$sqlDBManager->queryRows($sql);

	$items = array();
	if(!empty($res)){
		for($i=0;$i<count($res);$i++){
			array_push($items, $res[$i]);
		}	
	}else{
		array_push($items, NULL);
	}

	$result["rows"] = $items;

	echo json_encode($result);

?>